
* Classify the exports according to its material


gen knit=(HS2=="61")
gen woven=(HS2=="62")


gen wool=0
gen cotton=0
gen man_made=0
gen other_material=0
gen no_material=0
gen synthetic=0

replace	wool	=1	if HS6==	"620111"
replace	cotton	=1	if HS6==	"620112"
replace	man_made	=1	if HS6==	"620113"
replace	other_material	=1	if HS6==	"620119"
replace	wool	=1	if HS6==	"620191"
replace	cotton	=1	if HS6==	"620192"
replace	man_made	=1	if HS6==	"620193"
replace	other_material	=1	if HS6==	"620199"
replace	wool	=1	if HS6==	"620211"
replace	cotton	=1	if HS6==	"620212"
replace	man_made	=1	if HS6==	"620213"
replace	other_material	=1	if HS6==	"620219"
replace	wool	=1	if HS6==	"620291"
replace	cotton	=1	if HS6==	"620292"
replace	man_made	=1	if HS6==	"620293"
replace	other_material	=1	if HS6==	"620299"
replace	wool	=1	if HS6==	"620311"
replace	synthetic	=1	if HS6==	"620312"
replace	other_material	=1	if HS6==	"620319"
replace	wool	=1	if HS6==	"620321"
replace	cotton	=1	if HS6==	"620322"
replace	synthetic	=1	if HS6==	"620323"
replace	other_material	=1	if HS6==	"620329"
replace	wool	=1	if HS6==	"620331"
replace	cotton	=1	if HS6==	"620332"
replace	synthetic	=1	if HS6==	"620333"
replace	other_material	=1	if HS6==	"620339"
replace	wool	=1	if HS6==	"620341"
replace	cotton	=1	if HS6==	"620342"
replace	synthetic	=1	if HS6==	"620343"
replace	other_material	=1	if HS6==	"620349"
replace	wool	=1	if HS6==	"620411"
replace	cotton	=1	if HS6==	"620412"
replace	synthetic	=1	if HS6==	"620413"
replace	other_material	=1	if HS6==	"620419"
replace	wool	=1	if HS6==	"620421"
replace	cotton	=1	if HS6==	"620422"
replace	synthetic	=1	if HS6==	"620423"
replace	other_material	=1	if HS6==	"620429"
replace	wool	=1	if HS6==	"620431"
replace	cotton	=1	if HS6==	"620432"
replace	synthetic	=1	if HS6==	"620433"
replace	other_material	=1	if HS6==	"620439"
replace	wool	=1	if HS6==	"620441"
replace	cotton	=1	if HS6==	"620442"
replace	synthetic	=1	if HS6==	"620443"
replace	other_material	=1	if HS6==	"620444"
replace	other_material	=1	if HS6==	"620449"
replace	wool	=1	if HS6==	"620451"
replace	cotton	=1	if HS6==	"620452"
replace	synthetic	=1	if HS6==	"620453"
replace	other_material	=1	if HS6==	"620459"
replace	wool	=1	if HS6==	"620461"
replace	cotton	=1	if HS6==	"620462"
replace	synthetic	=1	if HS6==	"620463"
replace	other_material	=1	if HS6==	"620469"
replace	wool	=1	if HS6==	"620510"
replace	cotton	=1	if HS6==	"620520"
replace	man_made	=1	if HS6==	"620530"
replace	other_material	=1	if HS6==	"620590"
replace	other_material	=1	if HS6==	"620610"
replace	wool	=1	if HS6==	"620620"
replace	cotton	=1	if HS6==	"620630"
replace	man_made	=1	if HS6==	"620640"
replace	other_material	=1	if HS6==	"620690"
replace	cotton	=1	if HS6==	"620711"
replace	other_material	=1	if HS6==	"620719"
replace	cotton	=1	if HS6==	"620721"
replace	man_made	=1	if HS6==	"620722"
replace	other_material	=1	if HS6==	"620729"
replace	cotton	=1	if HS6==	"620791"
replace	man_made	=1	if HS6==	"620792"
replace	other_material	=1	if HS6==	"620799"
replace	man_made	=1	if HS6==	"620811"
replace	other_material	=1	if HS6==	"620819"
replace	cotton	=1	if HS6==	"620821"
replace	man_made	=1	if HS6==	"620822"
replace	other_material	=1	if HS6==	"620829"
replace	cotton	=1	if HS6==	"620891"
replace	man_made	=1	if HS6==	"620892"
replace	other_material	=1	if HS6==	"620899"
replace	wool	=1	if HS6==	"620910"
replace	cotton	=1	if HS6==	"620920"
replace	synthetic	=1	if HS6==	"620930"
replace	other_material	=1	if HS6==	"620990"
replace	no_material	=1	if HS6==	"621010"
replace	no_material	=1	if HS6==	"621020"
replace	no_material	=1	if HS6==	"621030"
replace	no_material	=1	if HS6==	"621040"
replace	no_material	=1	if HS6==	"621050"
replace	other_material	=1	if HS6==	"621111"
replace	other_material	=1	if HS6==	"621112"
replace	other_material	=1	if HS6==	"621120"
replace	wool	=1	if HS6==	"621131"
replace	cotton	=1	if HS6==	"621132"
replace	man_made	=1	if HS6==	"621133"
replace	other_material	=1	if HS6==	"621139"
replace	wool	=1	if HS6==	"621141"
replace	cotton	=1	if HS6==	"621142"
replace	man_made	=1	if HS6==	"621143"
replace	other_material	=1	if HS6==	"621149"
replace	other_material	=1	if HS6==	"621210"
replace	other_material	=1	if HS6==	"621220"
replace	other_material	=1	if HS6==	"621230"
replace	other_material	=1	if HS6==	"621290"
replace	other_material	=1	if HS6==	"621310"
replace	cotton	=1	if HS6==	"621320"
replace	other_material	=1	if HS6==	"621390"
replace	other_material	=1	if HS6==	"621410"
replace	wool	=1	if HS6==	"621420"
replace	synthetic	=1	if HS6==	"621430"
replace	other_material	=1	if HS6==	"621440"
replace	other_material	=1	if HS6==	"621490"
replace	other_material	=1	if HS6==	"621510"
replace	man_made	=1	if HS6==	"621520"
replace	other_material	=1	if HS6==	"621590"
replace	no_material	=1	if HS6==	"621600"
replace	no_material	=1	if HS6==	"621710"
replace	no_material	=1	if HS6==	"621790"

gen type_of_material=.
replace type_of_material=1 if cotton==1
replace type_of_material=2 if man_made==1
replace type_of_material=3 if synthetic==1
replace type_of_material=4 if wool==1
replace type_of_material=5 if other_material==1
replace type_of_material=6 if no_material==1

* label define type_of_material 1 "cotton" 2 "man_made" 3 "synthetic" 4 "wool" 5 "other_material" 6 "no_material" 
* label val type_of_material type_of_material


* Classify the exports according to the type of product

gen suit=0
gen ensamble=0
gen jacket=0
gen trouser=0
gen dress=0
gen skirt=0
gen shirt=0
gen other_product=0
gen tshirt=0
gen pullover=0
gen baby=0

replace	suit	=1	if HS6==	"620311"
replace	suit	=1	if HS6==	"620312"
replace	suit	=1	if HS6==	"620319"
replace	ensamble	=1	if HS6==	"620321"
replace	ensamble	=1	if HS6==	"620322"
replace	ensamble	=1	if HS6==	"620323"
replace	ensamble	=1	if HS6==	"620329"
replace	jacket	=1	if HS6==	"620331"
replace	jacket	=1	if HS6==	"620332"
replace	jacket	=1	if HS6==	"620333"
replace	jacket	=1	if HS6==	"620339"
replace	trouser	=1	if HS6==	"620341"
replace	trouser	=1	if HS6==	"620342"
replace	trouser	=1	if HS6==	"620343"
replace	trouser	=1	if HS6==	"620349"
replace	suit	=1	if HS6==	"620411"
replace	suit	=1	if HS6==	"620412"
replace	suit	=1	if HS6==	"620413"
replace	suit	=1	if HS6==	"620419"
replace	ensamble	=1	if HS6==	"620421"
replace	ensamble	=1	if HS6==	"620422"
replace	ensamble	=1	if HS6==	"620423"
replace	ensamble	=1	if HS6==	"620429"
replace	jacket	=1	if HS6==	"620431"
replace	jacket	=1	if HS6==	"620432"
replace	jacket	=1	if HS6==	"620433"
replace	jacket	=1	if HS6==	"620439"
replace	dress	=1	if HS6==	"620441"
replace	dress	=1	if HS6==	"620442"
replace	dress	=1	if HS6==	"620443"
replace	dress	=1	if HS6==	"620444"
replace	dress	=1	if HS6==	"620449"
replace	skirt	=1	if HS6==	"620451"
replace	skirt	=1	if HS6==	"620452"
replace	skirt	=1	if HS6==	"620453"
replace	skirt	=1	if HS6==	"620459"
replace	trouser	=1	if HS6==	"620461"
replace	trouser	=1	if HS6==	"620462"
replace	trouser	=1	if HS6==	"620463"
replace	trouser	=1	if HS6==	"620469"
replace shirt=1 if HS4=="6205"
replace shirt=1 if HS4=="6206"


gen type_of_product=.
replace type_of_product=1 if suit==1
replace type_of_product=2 if ensamble==1
replace type_of_product=3 if jacket==1
replace type_of_product=4 if trouser==1
replace type_of_product=5 if dress==1
replace type_of_product=6 if skirt==1
replace type_of_product=7 if shirt==1
replace type_of_product=8 if tshirt==1
replace type_of_product=9 if pullover==1
replace type_of_product=10 if baby==1

label define type_of_product 1 "suit" 2 "ensamble" 3 "jacket" 4 "trouser" 5 "dress" 6 "skirt" 7 "shirt" 8 "tshirt" 9 "pullover" 10 "baby" 0 "other product"
label val type_of_product type_of_product


* Classify the exports according to the gender (girls&women=women and boys&men=men)

gen women=0
gen men=0
gen both=0

replace women=1 if HS4=="6204"
replace women=1 if HS4=="6206"
replace men=1 if HS4=="6203"
replace men=1 if HS4=="6205"

gen gender=.
replace gender=1 if men==1
replace gender=2 if women==1
replace gender=3 if both==1

label define gender 1 "boys and men" 2 "girls and women" 3 "both"
label val gender gender

rename women female
rename men male

* classifying knitwear

* destring HS6, gen(HS6_num)

replace	other_product	=1 if HS6_num==	610110
replace	other_product	=1 if HS6_num==	610120
replace	other_product	=1 if HS6_num==	610130
replace	other_product	=1 if HS6_num==	610190
replace	other_product	=1 if HS6_num==	610210
replace	other_product	=1 if HS6_num==	610220
replace	other_product	=1 if HS6_num==	610230
replace	other_product	=1 if HS6_num==	610290
replace	suit	=1 if HS6_num==	610310
replace	suit	=1 if HS6_num==	610311
replace	suit	=1 if HS6_num==	610312
replace	suit	=1 if HS6_num==	610319
replace	ensamble	=1 if HS6_num==	610321
replace	ensamble	=1 if HS6_num==	610322
replace	ensamble	=1 if HS6_num==	610323
replace	ensamble	=1 if HS6_num==	610329
replace	jacket	=1 if HS6_num==	610331
replace	jacket	=1 if HS6_num==	610332
replace	jacket	=1 if HS6_num==	610333
replace	jacket	=1 if HS6_num==	610339
replace	trouser	=1 if HS6_num==	610341
replace	trouser	=1 if HS6_num==	610342
replace	trouser	=1 if HS6_num==	610343
replace	trouser	=1 if HS6_num==	610349
replace	suit	=1 if HS6_num==	610411
replace	suit	=1 if HS6_num==	610412
replace	suit	=1 if HS6_num==	610413
replace	suit	=1 if HS6_num==	610419
replace	ensamble	=1 if HS6_num==	610421
replace	ensamble	=1 if HS6_num==	610422
replace	ensamble	=1 if HS6_num==	610423
replace	ensamble	=1 if HS6_num==	610429
replace	jacket	=1 if HS6_num==	610431
replace	jacket	=1 if HS6_num==	610432
replace	jacket	=1 if HS6_num==	610433
replace	jacket	=1 if HS6_num==	610439
replace	dress	=1 if HS6_num==	610441
replace	dress	=1 if HS6_num==	610442
replace	dress	=1 if HS6_num==	610443
replace	dress	=1 if HS6_num==	610444
replace	dress	=1 if HS6_num==	610449
replace	skirt	=1 if HS6_num==	610451
replace	skirt	=1 if HS6_num==	610452
replace	skirt	=1 if HS6_num==	610453
replace	skirt	=1 if HS6_num==	610459
replace	trouser	=1 if HS6_num==	610461
replace	trouser	=1 if HS6_num==	610462
replace	trouser	=1 if HS6_num==	610463
replace	trouser	=1 if HS6_num==	610469
replace	shirt	=1 if HS6_num==	610510
replace	shirt	=1 if HS6_num==	610520
replace	shirt	=1 if HS6_num==	610590
replace	shirt	=1 if HS6_num==	610610
replace	shirt	=1 if HS6_num==	610620
replace	shirt	=1 if HS6_num==	610690
replace	other_product	=1 if HS6_num==	610711
replace	other_product	=1 if HS6_num==	610712
replace	other_product	=1 if HS6_num==	610719
replace	other_product	=1 if HS6_num==	610721
replace	other_product	=1 if HS6_num==	610722
replace	other_product	=1 if HS6_num==	610729
replace	other_product	=1 if HS6_num==	610791
replace	other_product	=1 if HS6_num==	610792
replace	other_product	=1 if HS6_num==	610799
replace	other_product	=1 if HS6_num==	610811
replace	other_product	=1 if HS6_num==	610819
replace	other_product	=1 if HS6_num==	610821
replace	other_product	=1 if HS6_num==	610822
replace	other_product	=1 if HS6_num==	610829
replace	other_product	=1 if HS6_num==	610831
replace	other_product	=1 if HS6_num==	610832
replace	other_product	=1 if HS6_num==	610839
replace	other_product	=1 if HS6_num==	610891
replace	other_product	=1 if HS6_num==	610892
replace	other_product	=1 if HS6_num==	610899
replace	tshirt	=1 if HS6_num==	610910
replace	tshirt	=1 if HS6_num==	610990
replace	pullover	=1 if HS6_num==	611011
replace	pullover	=1 if HS6_num==	611012
replace	pullover	=1 if HS6_num==	611019
replace	pullover	=1 if HS6_num==	611020
replace	pullover	=1 if HS6_num==	611030
replace	pullover	=1 if HS6_num==	611090
replace	baby	=1 if HS6_num==	611110
replace	baby	=1 if HS6_num==	611120
replace	baby	=1 if HS6_num==	611130
replace	baby	=1 if HS6_num==	611190
replace	other_product	=1 if HS6_num==	611211
replace	other_product	=1 if HS6_num==	611212
replace	other_product	=1 if HS6_num==	611219
replace	other_product	=1 if HS6_num==	611220
replace	other_product	=1 if HS6_num==	611231
replace	other_product	=1 if HS6_num==	611239
replace	other_product	=1 if HS6_num==	611241
replace	other_product	=1 if HS6_num==	611249
replace	other_product	=1 if HS6_num==	611300
replace	other_product	=1 if HS6_num==	611410
replace	other_product	=1 if HS6_num==	611420
replace	other_product	=1 if HS6_num==	611430
replace	other_product	=1 if HS6_num==	611490
replace	other_product	=1 if HS6_num==	611510
replace	other_product	=1 if HS6_num==	611511
replace	other_product	=1 if HS6_num==	611512
replace	other_product	=1 if HS6_num==	611519
replace	other_product	=1 if HS6_num==	611521
replace	other_product	=1 if HS6_num==	611522
replace	other_product	=1 if HS6_num==	611529
replace	other_product	=1 if HS6_num==	611530
replace	other_product	=1 if HS6_num==	611591
replace	other_product	=1 if HS6_num==	611592
replace	other_product	=1 if HS6_num==	611593
replace	other_product	=1 if HS6_num==	611594
replace	other_product	=1 if HS6_num==	611595
replace	other_product	=1 if HS6_num==	611596
replace	other_product	=1 if HS6_num==	611599
replace	other_product	=1 if HS6_num==	611610
replace	other_product	=1 if HS6_num==	611691
replace	other_product	=1 if HS6_num==	611692
replace	other_product	=1 if HS6_num==	611693
replace	other_product	=1 if HS6_num==	611699
replace	other_product	=1 if HS6_num==	611710
replace	other_product	=1 if HS6_num==	611720
replace	other_product	=1 if HS6_num==	611780
replace	other_product	=1 if HS6_num==	611790


replace type_of_product=1 if suit==1
replace type_of_product=2 if ensamble==1
replace type_of_product=3 if jacket==1
replace type_of_product=4 if trouser==1
replace type_of_product=5 if dress==1
replace type_of_product=6 if skirt==1
replace type_of_product=7 if shirt==1
replace type_of_product=8 if tshirt==1
replace type_of_product=9 if pullover==1
replace type_of_product=10 if baby==1
replace type_of_product=0 if type_of_product==.
replace other_product=1 if type_of_product==0

replace	no_material	=1 if HS6_num==	610110
replace	cotton	=1 if HS6_num==	610120
replace	man_made	=1 if HS6_num==	610130
replace	other_mat	=1 if HS6_num==	610190
replace	wool	=1 if HS6_num==	610210
replace	cotton	=1 if HS6_num==	610220
replace	man_made	=1 if HS6_num==	610230
replace	other_mat	=1 if HS6_num==	610290
replace	wool	=1 if HS6_num==	610310
replace	cotton	=1 if HS6_num==	610311
replace	synthetic	=1 if HS6_num==	610312
replace	other_mat	=1 if HS6_num==	610319
replace	wool	=1 if HS6_num==	610321
replace	cotton	=1 if HS6_num==	610322
replace	synthetic	=1 if HS6_num==	610323
replace	other_mat	=1 if HS6_num==	610329
replace	wool	=1 if HS6_num==	610331
replace	cotton	=1 if HS6_num==	610332
replace	synthetic	=1 if HS6_num==	610333
replace	other_mat	=1 if HS6_num==	610339
replace	wool	=1 if HS6_num==	610341
replace	cotton	=1 if HS6_num==	610342
replace	synthetic	=1 if HS6_num==	610343
replace	other_mat	=1 if HS6_num==	610349
replace	wool	=1 if HS6_num==	610411
replace	cotton	=1 if HS6_num==	610412
replace	synthetic	=1 if HS6_num==	610413
replace	other_mat	=1 if HS6_num==	610419
replace	wool	=1 if HS6_num==	610421
replace	cotton	=1 if HS6_num==	610422
replace	synthetic	=1 if HS6_num==	610423
replace	other_mat	=1 if HS6_num==	610429
replace	wool	=1 if HS6_num==	610431
replace	cotton	=1 if HS6_num==	610432
replace	synthetic	=1 if HS6_num==	610433
replace	other_mat	=1 if HS6_num==	610439
replace	wool	=1 if HS6_num==	610441
replace	cotton	=1 if HS6_num==	610442
replace	synthetic	=1 if HS6_num==	610443
replace	man_made	=1 if HS6_num==	610444
replace	other_mat	=1 if HS6_num==	610449
replace	wool	=1 if HS6_num==	610451
replace	cotton	=1 if HS6_num==	610452
replace	synthetic	=1 if HS6_num==	610453
replace	other_mat	=1 if HS6_num==	610459
replace	wool	=1 if HS6_num==	610461
replace	cotton	=1 if HS6_num==	610462
replace	synthetic	=1 if HS6_num==	610463
replace	other_mat	=1 if HS6_num==	610469
replace	cotton	=1 if HS6_num==	610510
replace	man_made	=1 if HS6_num==	610520
replace	other_mat	=1 if HS6_num==	610590
replace	cotton	=1 if HS6_num==	610610
replace	man_made	=1 if HS6_num==	610620
replace	other_mat	=1 if HS6_num==	610690
replace	cotton	=1 if HS6_num==	610711
replace	man_made	=1 if HS6_num==	610712
replace	other_mat	=1 if HS6_num==	610719
replace	cotton	=1 if HS6_num==	610721
replace	man_made	=1 if HS6_num==	610722
replace	other_mat	=1 if HS6_num==	610729
replace	cotton	=1 if HS6_num==	610791
replace	man_made	=1 if HS6_num==	610792
replace	other_mat	=1 if HS6_num==	610799
replace	cotton	=1 if HS6_num==	610811
replace	other_mat	=1 if HS6_num==	610819
replace	cotton	=1 if HS6_num==	610821
replace	man_made	=1 if HS6_num==	610822
replace	other_mat	=1 if HS6_num==	610829
replace	cotton	=1 if HS6_num==	610831
replace	man_made	=1 if HS6_num==	610832
replace	other_mat	=1 if HS6_num==	610839
replace	cotton	=1 if HS6_num==	610891
replace	man_made	=1 if HS6_num==	610892
replace	other_mat	=1 if HS6_num==	610899
replace	cotton	=1 if HS6_num==	610910
replace	other_mat	=1 if HS6_num==	610990
replace	wool	=1 if HS6_num==	611011
replace	wool	=1 if HS6_num==	611012
replace	wool	=1 if HS6_num==	611019
replace	cotton	=1 if HS6_num==	611020
replace	man_made	=1 if HS6_num==	611030
replace	other_mat	=1 if HS6_num==	611090
replace	cotton	=1 if HS6_num==	611110
replace	man_made	=1 if HS6_num==	611120
replace	synthetic	=1 if HS6_num==	611130
replace	other_mat	=1 if HS6_num==	611190
replace	cotton	=1 if HS6_num==	611211
replace	cotton	=1 if HS6_num==	611212
replace	other_mat	=1 if HS6_num==	611219
replace	other_mat	=1 if HS6_num==	611220
replace	synthetic	=1 if HS6_num==	611231
replace	other_mat	=1 if HS6_num==	611239
replace	synthetic	=1 if HS6_num==	611241
replace	other_mat	=1 if HS6_num==	611249
replace	other_mat	=1 if HS6_num==	611300
replace	wool	=1 if HS6_num==	611410
replace	cotton	=1 if HS6_num==	611420
replace	man_made	=1 if HS6_num==	611430
replace	other_mat	=1 if HS6_num==	611490
replace	man_made	=1 if HS6_num==	611510
replace	man_made	=1 if HS6_num==	611511
replace	other_mat	=1 if HS6_num==	611512
replace	other_mat	=1 if HS6_num==	611519
replace	cotton	=1 if HS6_num==	611521
replace	synthetic	=1 if HS6_num==	611522
replace	other_mat	=1 if HS6_num==	611529
replace	cotton	=1 if HS6_num==	611530
replace	cotton	=1 if HS6_num==	611591
replace	man_made	=1 if HS6_num==	611592
replace	synthetic	=1 if HS6_num==	611593
replace	other_mat	=1 if HS6_num==	611594
replace	other_mat	=1 if HS6_num==	611595
replace	other_mat	=1 if HS6_num==	611596
replace	other_mat	=1 if HS6_num==	611599
replace	other_mat	=1 if HS6_num==	611610
replace	wool	=1 if HS6_num==	611691
replace	cotton	=1 if HS6_num==	611692
replace	synthetic	=1 if HS6_num==	611693
replace	other_mat	=1 if HS6_num==	611699
replace	other_mat	=1 if HS6_num==	611710
replace	other_mat	=1 if HS6_num==	611720
replace	other_mat	=1 if HS6_num==	611780
replace	other_mat	=1 if HS6_num==	611790

replace type_of_material=1 if cotton==1
replace type_of_material=2 if man_made==1
replace type_of_material=3 if synthetic==1
replace type_of_material=4 if wool==1
replace type_of_material=5 if other_material==1
replace type_of_material=6 if no_material==1

replace	male	=1 if HS6_num==	610110
replace	male	=1 if HS6_num==	610120
replace	male	=1 if HS6_num==	610130
replace	male	=1 if HS6_num==	610190
replace	female	=1 if HS6_num==	610210
replace	female	=1 if HS6_num==	610220
replace	female	=1 if HS6_num==	610230
replace	female	=1 if HS6_num==	610290
replace	male	=1 if HS6_num==	610310
replace	male	=1 if HS6_num==	610311
replace	male	=1 if HS6_num==	610312
replace	male	=1 if HS6_num==	610319
replace	male	=1 if HS6_num==	610321
replace	male	=1 if HS6_num==	610322
replace	male	=1 if HS6_num==	610323
replace	male	=1 if HS6_num==	610329
replace	male	=1 if HS6_num==	610331
replace	male	=1 if HS6_num==	610332
replace	male	=1 if HS6_num==	610333
replace	male	=1 if HS6_num==	610339
replace	male	=1 if HS6_num==	610341
replace	male	=1 if HS6_num==	610342
replace	male	=1 if HS6_num==	610343
replace	male	=1 if HS6_num==	610349
replace	female	=1 if HS6_num==	610411
replace	female	=1 if HS6_num==	610412
replace	female	=1 if HS6_num==	610413
replace	female	=1 if HS6_num==	610419
replace	female	=1 if HS6_num==	610421
replace	female	=1 if HS6_num==	610422
replace	female	=1 if HS6_num==	610423
replace	female	=1 if HS6_num==	610429
replace	female	=1 if HS6_num==	610431
replace	female	=1 if HS6_num==	610432
replace	female	=1 if HS6_num==	610433
replace	female	=1 if HS6_num==	610439
replace	female	=1 if HS6_num==	610441
replace	female	=1 if HS6_num==	610442
replace	female	=1 if HS6_num==	610443
replace	female	=1 if HS6_num==	610444
replace	female	=1 if HS6_num==	610449
replace	female	=1 if HS6_num==	610451
replace	female	=1 if HS6_num==	610452
replace	female	=1 if HS6_num==	610453
replace	female	=1 if HS6_num==	610459
replace	female	=1 if HS6_num==	610461
replace	female	=1 if HS6_num==	610462
replace	female	=1 if HS6_num==	610463
replace	female	=1 if HS6_num==	610469
replace	male	=1 if HS6_num==	610510
replace	male	=1 if HS6_num==	610520
replace	male	=1 if HS6_num==	610590
replace	female	=1 if HS6_num==	610610
replace	female	=1 if HS6_num==	610620
replace	female	=1 if HS6_num==	610690
replace	male	=1 if HS6_num==	610711
replace	male	=1 if HS6_num==	610712
replace	male	=1 if HS6_num==	610719
replace	male	=1 if HS6_num==	610721
replace	male	=1 if HS6_num==	610722
replace	male	=1 if HS6_num==	610729
replace	male	=1 if HS6_num==	610791
replace	male	=1 if HS6_num==	610792
replace	male	=1 if HS6_num==	610799
replace	female	=1 if HS6_num==	610811
replace	female	=1 if HS6_num==	610819
replace	female	=1 if HS6_num==	610821
replace	female	=1 if HS6_num==	610822
replace	female	=1 if HS6_num==	610829
replace	female	=1 if HS6_num==	610831
replace	female	=1 if HS6_num==	610832
replace	female	=1 if HS6_num==	610839
replace	female	=1 if HS6_num==	610891
replace	female	=1 if HS6_num==	610892
replace	female	=1 if HS6_num==	610899
replace	both	=1 if HS6_num==	610910
replace	both	=1 if HS6_num==	610990
replace	both	=1 if HS6_num==	611011
replace	both	=1 if HS6_num==	611012
replace	both	=1 if HS6_num==	611019
replace	both	=1 if HS6_num==	611020
replace	both	=1 if HS6_num==	611030
replace	both	=1 if HS6_num==	611090
replace	both	=1 if HS6_num==	611110
replace	both	=1 if HS6_num==	611120
replace	both	=1 if HS6_num==	611130
replace	both	=1 if HS6_num==	611190
replace	both	=1 if HS6_num==	611211
replace	both	=1 if HS6_num==	611212
replace	both	=1 if HS6_num==	611219
replace	both	=1 if HS6_num==	611220
replace	male	=1 if HS6_num==	611231
replace	male	=1 if HS6_num==	611239
replace	female	=1 if HS6_num==	611241
replace	female	=1 if HS6_num==	611249
replace	both	=1 if HS6_num==	611300
replace	both	=1 if HS6_num==	611410
replace	both	=1 if HS6_num==	611420
replace	both	=1 if HS6_num==	611430
replace	both	=1 if HS6_num==	611490
replace	both	=1 if HS6_num==	611510
replace	both	=1 if HS6_num==	611511
replace	both	=1 if HS6_num==	611512
replace	both	=1 if HS6_num==	611519
replace	both	=1 if HS6_num==	611521
replace	both	=1 if HS6_num==	611522
replace	both	=1 if HS6_num==	611529
replace	both	=1 if HS6_num==	611530
replace	both	=1 if HS6_num==	611591
replace	both	=1 if HS6_num==	611592
replace	both	=1 if HS6_num==	611593
replace	both	=1 if HS6_num==	611594
replace	both	=1 if HS6_num==	611595
replace	both	=1 if HS6_num==	611596
replace	both	=1 if HS6_num==	611599
replace	both	=1 if HS6_num==	611610
replace	both	=1 if HS6_num==	611691
replace	both	=1 if HS6_num==	611692
replace	both	=1 if HS6_num==	611693
replace	both	=1 if HS6_num==	611699
replace	both	=1 if HS6_num==	611710
replace	both	=1 if HS6_num==	611720
replace	both	=1 if HS6_num==	611780
replace	both	=1 if HS6_num==	611790


replace gender=1 if male==1
replace gender=2 if female==1
replace gender=3 if both==1
